<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

    // http://maestric.com/doc/php/codeigniter_models

    class MY_Model extends CI_Model {

        var $table = "";

        function __construct()
        {
            parent::__construct();
            $this->load->database();
        }

        function insert($data)
        {
            $this->db->insert($this->table, $data);
            return $this->db->insert_id();
        }

        function find_id($id)
        {
            if ($id == NULL)
            {
                return NULL;
            }

            $this->db->where('ID', $id);
            $query = $this->db->get($this->table);

            $result = $query->result_array();
            return (count($result) > 0 ? $result[0] : NULL);
        }

        function find_all($sort = 'ID', $order = 'ASC')
        {
            $this->db->order_by($sort, $order);
            $query = $this->db->get($this->table);
            return $query->result_array();
        }

        function update($id, $data)
        {
            $this->db->where('ID', $id);
            $this->db->update($this->table, $data);
        }

        function delete($id)
        {
            if ($id != NULL)
            {
                $this->db->where('ID', $id);                    
                $this->db->delete($this->table);                        
            }
        }       
    }

    /* End of file MY_Model.php */
    /* Location: ./system/application/libraries/MY_Model.php */